2014-10-03 - 14840.100 - Enhancement - Add inbound delivery to SH100 and SH101 #SalesDistribution
Enhancement
14840.100 - Add inbound delivery to SH100 and SH101
Requirement Summary
Need to add inbound delivery to SH100 and SH101 reports.
Admin Info
Purpose
|
Need to add inbound delivery to SH100 and SH101 reports.
|
Requested By
|
Inger Nordby
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
12/25/2014
|
Spec QA by
|
Uday Kumar P
|
Objects
|
ZSD_INBD, ZSD_EKKN, ZSD_SHIP & ZIC_SHIP.
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
32
|
2
|
Documentation
|
08
|
3
|
Development/Config
|
72
|
4
|
Unit test in DEV
|
24
|
5
|
Unit test in QUA
|
16
|
6
|
Transports
|
08
|
|
TOTAL
|
160
|
References
Prior Tickets
None
Documents
Inbound Deliveries Spec.xlsx
Functional Requirement
Purpose/WHY:
The shipped cube used currently is only fetching the outbound deliveries but the information of the inbound deliveries is being excluded in the 2LIS_12_VCITM standard extractor. In order to the fetch the inbound deliveries into the shipped cube a new design has been implemented.
In Scope:
Enhancement in Shipped DSO and infocube.
Out of Scope:
None
Solution Summary
1. Need to create database view on LIKP & LIPS tables with the required fields to fetch only the inbound deliveries with condition delivery type LFART = 'EL'.
2. Need to create generic view on EKKO, EKKN & EKPO tables with the required fields to fetch only the Document type 'Z3NB'(third party) Orders.
3. Need to create the Generic datasources based on above views.
3. Need to create the new info objects for inbound delivery quantites.
3. Need to create DSO's with the required info objects as mentioned in the specification.
4. Need to create the dataflows for DSO's with corresponding generic datasources.
5. Need to add the newly created inf oobjects in Shipped DSO & Shipped Cube.
6. Need to add the corresponding changes in all the regional sources.
7. Need to change the shipped process chain as per the new design.
8. Need to change the BEx Queries for SH100 & SH101 as per the new changes.
6. Need to collect all the required changes into the Transport requests.
Test Plan
SNo
|
Test Scenario
|
Expected Results
|
1.
|
Check if the Database views are populating the data as per the conditions specified.
|
Database views should populate data as per the specified conditions.
|
2.
|
Check if the inbound deliveries are being extracted only for Z3NB Purchase Orders.
|
Inbound deliveries sholud be extracted only for the Z3NB Purchase orders.
|
3
|
Check if the data is aligned correctly in Shipped DSO for inbound deliveries.
|
Data should be aligned correctly for the Inbound deliveries.
|
4
|
Check if the required dataflow changes are done in the regional sources.
|
All the required regional changes should be done.
|
3.
|
Check whether all the required changes are collected into the Transport Requests.
|
All the Changes should be collected into the tranport requests.
|
Solution Details
1. Need to create database view on LIKP & LIPS tables(ZLIKP_LIPS) with the required fields to fetch only the inbound deliveries with condition delivery type LFART = 'EL'.
2. Need to create generic view on EKKO, EKKN & EKPO(ZEKKO_EKKN) tables with the required fields to fetch only the document type 'Z3NB'(third party) Orders.
3. Need to create the Generic datasources based on views ZDS_LIKP_LIPS and ZDS_EKKN.
3. Need to create the new info objects for inbound delivery quantites ZINB_QTY and ZINBQTEA.
3. Need to create DSO's ZSD_LIKP_LIPS and ZSD_EKKN with the required info objects as mentioned in the Specification.
4. Need to create the dataflows for DSO's ZSD_LIKP_LIPS, ZSD_EKKN with corresponding generic datasources ZDS_LIKP_LIPS, ZDS_EKKN..
5. Need to add the newly created info objects in Shipped DSO ZSD_SHIP & Shipped Cube ZIC_SHIP.
6. Need to add the corresponding changes in all the regional sources Z_SHIP.
7. Need to add the new changes the shipped process chain ZPC_SHIP.
8. Need to change the BEx Queries for SH100 & SH101 as per the new changes.
9. Need to collect all the required changes into the Transport requests.
Issues
1. Due to inconsistent data in NECNED300 we need to do detailed testing for all the possible scenarios in BPQ.
2. Due to multiple changes in the requirement frequently development got delayed beyond expected time.